import PyQt5
from PyQt5.QtWidgets import QTableWidgetItem, QFileDialog
from qtpy import QtWidgets
from tools import Tools
import os
from openpyxl import load_workbook


def read_excel():
    res=[]
    wb=load_workbook("./cam.xlsx")
    ws=wb["Sheet1"]
    for  i in range(2,ws.max_row+1):
        row=[]
        for col in range(1,8):
            d=ws.cell(row=i,column=col).value
            if d is None or d=="":
                break
            row.append(str(d))
        if len(row)==7:
            res.append(row)
    return res
if __name__ == '__main__':
    res=read_excel()
    print (res)
